﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AutomotivePricingDataSet" targetNamespace="http://tempuri.org/AutomotivePricingDataSet.xsd" xmlns:mstns="http://tempuri.org/AutomotivePricingDataSet.xsd" xmlns="http://tempuri.org/AutomotivePricingDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AutomotivePricingModel_AutomotivePricingDatabaseContextConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AutomotivePricingModel_AutomotivePricingDatabaseContextConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.AutomotivePricingModel.Properties.Settings.GlobalReference.Default.AutomotivePricingModel_AutomotivePricingDatabaseContextConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables />
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AutomotivePricingDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="AutomotivePricingDataSet" msprop:Generator_UserDSName="AutomotivePricingDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="BodyStyles" msprop:Generator_TableClassName="BodyStylesDataTable" msprop:Generator_TableVarName="tableBodyStyles" msprop:Generator_TablePropName="BodyStyles" msprop:Generator_RowDeletingName="BodyStylesRowDeleting" msprop:Generator_UserTableName="BodyStyles" msprop:Generator_RowChangingName="BodyStylesRowChanging" msprop:Generator_RowEvHandlerName="BodyStylesRowChangeEventHandler" msprop:Generator_RowDeletedName="BodyStylesRowDeleted" msprop:Generator_RowEvArgName="BodyStylesRowChangeEvent" msprop:Generator_RowChangedName="BodyStylesRowChanged" msprop:Generator_RowClassName="BodyStylesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_BodyStyleId" msprop:Generator_ColumnVarNameInTable="columnEF_BodyStyleId" msprop:Generator_ColumnPropNameInRow="EF_BodyStyleId" msprop:Generator_ColumnPropNameInTable="EF_BodyStyleIdColumn" msprop:Generator_UserColumnName="EF_BodyStyleId" type="xs:int" />
              <xs:element name="DisplayName" msprop:Generator_ColumnVarNameInTable="columnDisplayName" msprop:Generator_ColumnPropNameInRow="DisplayName" msprop:Generator_ColumnPropNameInTable="DisplayNameColumn" msprop:Generator_UserColumnName="DisplayName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="YearValueObservations" msprop:Generator_TableClassName="YearValueObservationsDataTable" msprop:Generator_TableVarName="tableYearValueObservations" msprop:Generator_TablePropName="YearValueObservations" msprop:Generator_RowDeletingName="YearValueObservationsRowDeleting" msprop:Generator_UserTableName="YearValueObservations" msprop:Generator_RowChangingName="YearValueObservationsRowChanging" msprop:Generator_RowEvHandlerName="YearValueObservationsRowChangeEventHandler" msprop:Generator_RowDeletedName="YearValueObservationsRowDeleted" msprop:Generator_RowEvArgName="YearValueObservationsRowChangeEvent" msprop:Generator_RowChangedName="YearValueObservationsRowChanged" msprop:Generator_RowClassName="YearValueObservationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" msprop:Generator_UserColumnName="Year" type="xs:int" />
              <xs:element name="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnPropNameInTable="ValueColumn" msprop:Generator_UserColumnName="Value" type="xs:double" />
              <xs:element name="ParentYearlyFinancialAssessmentId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentYearlyFinancialAssessmentId" msprop:Generator_ColumnPropNameInRow="ParentYearlyFinancialAssessmentId" msprop:Generator_ColumnPropNameInTable="ParentYearlyFinancialAssessmentIdColumn" msprop:Generator_UserColumnName="ParentYearlyFinancialAssessmentId" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Brands" msprop:Generator_TableClassName="BrandsDataTable" msprop:Generator_TableVarName="tableBrands" msprop:Generator_TablePropName="Brands" msprop:Generator_RowDeletingName="BrandsRowDeleting" msprop:Generator_UserTableName="Brands" msprop:Generator_RowChangingName="BrandsRowChanging" msprop:Generator_RowEvHandlerName="BrandsRowChangeEventHandler" msprop:Generator_RowDeletedName="BrandsRowDeleted" msprop:Generator_RowEvArgName="BrandsRowChangeEvent" msprop:Generator_RowChangedName="BrandsRowChanged" msprop:Generator_RowClassName="BrandsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_BrandId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_BrandId" msprop:Generator_ColumnPropNameInRow="EF_BrandId" msprop:Generator_ColumnPropNameInTable="EF_BrandIdColumn" msprop:Generator_UserColumnName="EF_BrandId" type="xs:string" />
              <xs:element name="OwningCompany" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOwningCompany" msprop:Generator_ColumnPropNameInRow="OwningCompany" msprop:Generator_ColumnPropNameInTable="OwningCompanyColumn" msprop:Generator_UserColumnName="OwningCompany" type="xs:string" minOccurs="0" />
              <xs:element name="CountryOfOrigin" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCountryOfOrigin" msprop:Generator_ColumnPropNameInRow="CountryOfOrigin" msprop:Generator_ColumnPropNameInTable="CountryOfOriginColumn" msprop:Generator_UserColumnName="CountryOfOrigin" type="xs:string" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BrandCreationDate" msprop:Generator_ColumnVarNameInTable="columnBrandCreationDate" msprop:Generator_ColumnPropNameInRow="BrandCreationDate" msprop:Generator_ColumnPropNameInTable="BrandCreationDateColumn" msprop:Generator_UserColumnName="BrandCreationDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Companies" msprop:Generator_TableClassName="CompaniesDataTable" msprop:Generator_TableVarName="tableCompanies" msprop:Generator_TablePropName="Companies" msprop:Generator_RowDeletingName="CompaniesRowDeleting" msprop:Generator_UserTableName="Companies" msprop:Generator_RowChangingName="CompaniesRowChanging" msprop:Generator_RowEvHandlerName="CompaniesRowChangeEventHandler" msprop:Generator_RowDeletedName="CompaniesRowDeleted" msprop:Generator_RowEvArgName="CompaniesRowChangeEvent" msprop:Generator_RowChangedName="CompaniesRowChanged" msprop:Generator_RowClassName="CompaniesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_CompanyId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_CompanyId" msprop:Generator_ColumnPropNameInRow="EF_CompanyId" msprop:Generator_ColumnPropNameInTable="EF_CompanyIdColumn" msprop:Generator_UserColumnName="EF_CompanyId" type="xs:string" />
              <xs:element name="CountryOfHeadquarters" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCountryOfHeadquarters" msprop:Generator_ColumnPropNameInRow="CountryOfHeadquarters" msprop:Generator_ColumnPropNameInTable="CountryOfHeadquartersColumn" msprop:Generator_UserColumnName="CountryOfHeadquarters" type="xs:string" minOccurs="0" />
              <xs:element name="CompanyName" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CeoName" msprop:Generator_ColumnVarNameInTable="columnCeoName" msprop:Generator_ColumnPropNameInRow="CeoName" msprop:Generator_ColumnPropNameInTable="CeoNameColumn" msprop:Generator_UserColumnName="CeoName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FounderName" msprop:Generator_ColumnVarNameInTable="columnFounderName" msprop:Generator_ColumnPropNameInRow="FounderName" msprop:Generator_ColumnPropNameInTable="FounderNameColumn" msprop:Generator_UserColumnName="FounderName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyFoundingDate" msprop:Generator_ColumnVarNameInTable="columnCompanyFoundingDate" msprop:Generator_ColumnPropNameInRow="CompanyFoundingDate" msprop:Generator_ColumnPropNameInTable="CompanyFoundingDateColumn" msprop:Generator_UserColumnName="CompanyFoundingDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EF_EarningsHistoryId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_EarningsHistoryId" msprop:Generator_ColumnPropNameInRow="EF_EarningsHistoryId" msprop:Generator_ColumnPropNameInTable="EF_EarningsHistoryIdColumn" msprop:Generator_UserColumnName="EF_EarningsHistoryId" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Countries" msprop:Generator_TableClassName="CountriesDataTable" msprop:Generator_TableVarName="tableCountries" msprop:Generator_TablePropName="Countries" msprop:Generator_RowDeletingName="CountriesRowDeleting" msprop:Generator_UserTableName="Countries" msprop:Generator_RowChangingName="CountriesRowChanging" msprop:Generator_RowEvHandlerName="CountriesRowChangeEventHandler" msprop:Generator_RowDeletedName="CountriesRowDeleted" msprop:Generator_RowEvArgName="CountriesRowChangeEvent" msprop:Generator_RowChangedName="CountriesRowChanged" msprop:Generator_RowClassName="CountriesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_CountryId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_CountryId" msprop:Generator_ColumnPropNameInRow="EF_CountryId" msprop:Generator_ColumnPropNameInTable="EF_CountryIdColumn" msprop:Generator_UserColumnName="EF_CountryId" type="xs:string" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DealerBrandRelations" msprop:Generator_TableClassName="DealerBrandRelationsDataTable" msprop:Generator_TableVarName="tableDealerBrandRelations" msprop:Generator_TablePropName="DealerBrandRelations" msprop:Generator_RowDeletingName="DealerBrandRelationsRowDeleting" msprop:Generator_UserTableName="DealerBrandRelations" msprop:Generator_RowChangingName="DealerBrandRelationsRowChanging" msprop:Generator_RowEvHandlerName="DealerBrandRelationsRowChangeEventHandler" msprop:Generator_RowDeletedName="DealerBrandRelationsRowDeleted" msprop:Generator_RowEvArgName="DealerBrandRelationsRowChangeEvent" msprop:Generator_RowChangedName="DealerBrandRelationsRowChanged" msprop:Generator_RowClassName="DealerBrandRelationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ParentDealerId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentDealerId" msprop:Generator_ColumnPropNameInRow="ParentDealerId" msprop:Generator_ColumnPropNameInTable="ParentDealerIdColumn" msprop:Generator_UserColumnName="ParentDealerId" type="xs:string" />
              <xs:element name="RelatedBrandId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnRelatedBrandId" msprop:Generator_ColumnPropNameInRow="RelatedBrandId" msprop:Generator_ColumnPropNameInTable="RelatedBrandIdColumn" msprop:Generator_UserColumnName="RelatedBrandId" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Dealers" msprop:Generator_TableClassName="DealersDataTable" msprop:Generator_TableVarName="tableDealers" msprop:Generator_TablePropName="Dealers" msprop:Generator_RowDeletingName="DealersRowDeleting" msprop:Generator_UserTableName="Dealers" msprop:Generator_RowChangingName="DealersRowChanging" msprop:Generator_RowEvHandlerName="DealersRowChangeEventHandler" msprop:Generator_RowDeletedName="DealersRowDeleted" msprop:Generator_RowEvArgName="DealersRowChangeEvent" msprop:Generator_RowChangedName="DealersRowChanged" msprop:Generator_RowClassName="DealersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_DealerId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_DealerId" msprop:Generator_ColumnPropNameInRow="EF_DealerId" msprop:Generator_ColumnPropNameInTable="EF_DealerIdColumn" msprop:Generator_UserColumnName="EF_DealerId" type="xs:string" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DealerVehicleRelations" msprop:Generator_TableClassName="DealerVehicleRelationsDataTable" msprop:Generator_TableVarName="tableDealerVehicleRelations" msprop:Generator_TablePropName="DealerVehicleRelations" msprop:Generator_RowDeletingName="DealerVehicleRelationsRowDeleting" msprop:Generator_UserTableName="DealerVehicleRelations" msprop:Generator_RowChangingName="DealerVehicleRelationsRowChanging" msprop:Generator_RowEvHandlerName="DealerVehicleRelationsRowChangeEventHandler" msprop:Generator_RowDeletedName="DealerVehicleRelationsRowDeleted" msprop:Generator_RowEvArgName="DealerVehicleRelationsRowChangeEvent" msprop:Generator_RowChangedName="DealerVehicleRelationsRowChanged" msprop:Generator_RowClassName="DealerVehicleRelationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ParentDealerId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentDealerId" msprop:Generator_ColumnPropNameInRow="ParentDealerId" msprop:Generator_ColumnPropNameInTable="ParentDealerIdColumn" msprop:Generator_UserColumnName="ParentDealerId" type="xs:string" />
              <xs:element name="RelatedVehicleId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnRelatedVehicleId" msprop:Generator_ColumnPropNameInRow="RelatedVehicleId" msprop:Generator_ColumnPropNameInTable="RelatedVehicleIdColumn" msprop:Generator_UserColumnName="RelatedVehicleId" type="xs:string" />
              <xs:element name="VehicleCount" msprop:Generator_ColumnVarNameInTable="columnVehicleCount" msprop:Generator_ColumnPropNameInRow="VehicleCount" msprop:Generator_ColumnPropNameInTable="VehicleCountColumn" msprop:Generator_UserColumnName="VehicleCount" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DriveTrainTypes" msprop:Generator_TableClassName="DriveTrainTypesDataTable" msprop:Generator_TableVarName="tableDriveTrainTypes" msprop:Generator_TablePropName="DriveTrainTypes" msprop:Generator_RowDeletingName="DriveTrainTypesRowDeleting" msprop:Generator_UserTableName="DriveTrainTypes" msprop:Generator_RowChangingName="DriveTrainTypesRowChanging" msprop:Generator_RowEvHandlerName="DriveTrainTypesRowChangeEventHandler" msprop:Generator_RowDeletedName="DriveTrainTypesRowDeleted" msprop:Generator_RowEvArgName="DriveTrainTypesRowChangeEvent" msprop:Generator_RowChangedName="DriveTrainTypesRowChanged" msprop:Generator_RowClassName="DriveTrainTypesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_DriveTrainTypeId" msprop:Generator_ColumnVarNameInTable="columnEF_DriveTrainTypeId" msprop:Generator_ColumnPropNameInRow="EF_DriveTrainTypeId" msprop:Generator_ColumnPropNameInTable="EF_DriveTrainTypeIdColumn" msprop:Generator_UserColumnName="EF_DriveTrainTypeId" type="xs:int" />
              <xs:element name="DisplayName" msprop:Generator_ColumnVarNameInTable="columnDisplayName" msprop:Generator_ColumnPropNameInRow="DisplayName" msprop:Generator_ColumnPropNameInTable="DisplayNameColumn" msprop:Generator_UserColumnName="DisplayName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ProductionModels" msprop:Generator_TableClassName="ProductionModelsDataTable" msprop:Generator_TableVarName="tableProductionModels" msprop:Generator_TablePropName="ProductionModels" msprop:Generator_RowDeletingName="ProductionModelsRowDeleting" msprop:Generator_UserTableName="ProductionModels" msprop:Generator_RowChangingName="ProductionModelsRowChanging" msprop:Generator_RowEvHandlerName="ProductionModelsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductionModelsRowDeleted" msprop:Generator_RowEvArgName="ProductionModelsRowChangeEvent" msprop:Generator_RowChangedName="ProductionModelsRowChanged" msprop:Generator_RowClassName="ProductionModelsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_ProductionModelId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_ProductionModelId" msprop:Generator_ColumnPropNameInRow="EF_ProductionModelId" msprop:Generator_ColumnPropNameInTable="EF_ProductionModelIdColumn" msprop:Generator_UserColumnName="EF_ProductionModelId" type="xs:string" />
              <xs:element name="ParentBrand" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentBrand" msprop:Generator_ColumnPropNameInRow="ParentBrand" msprop:Generator_ColumnPropNameInTable="ParentBrandColumn" msprop:Generator_UserColumnName="ParentBrand" type="xs:string" minOccurs="0" />
              <xs:element name="ModelName" msprop:Generator_ColumnVarNameInTable="columnModelName" msprop:Generator_ColumnPropNameInRow="ModelName" msprop:Generator_ColumnPropNameInTable="ModelNameColumn" msprop:Generator_UserColumnName="ModelName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TransmissionTypes" msprop:Generator_TableClassName="TransmissionTypesDataTable" msprop:Generator_TableVarName="tableTransmissionTypes" msprop:Generator_TablePropName="TransmissionTypes" msprop:Generator_RowDeletingName="TransmissionTypesRowDeleting" msprop:Generator_UserTableName="TransmissionTypes" msprop:Generator_RowChangingName="TransmissionTypesRowChanging" msprop:Generator_RowEvHandlerName="TransmissionTypesRowChangeEventHandler" msprop:Generator_RowDeletedName="TransmissionTypesRowDeleted" msprop:Generator_RowEvArgName="TransmissionTypesRowChangeEvent" msprop:Generator_RowChangedName="TransmissionTypesRowChanged" msprop:Generator_RowClassName="TransmissionTypesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_TransmissionTypeId" msprop:Generator_ColumnVarNameInTable="columnEF_TransmissionTypeId" msprop:Generator_ColumnPropNameInRow="EF_TransmissionTypeId" msprop:Generator_ColumnPropNameInTable="EF_TransmissionTypeIdColumn" msprop:Generator_UserColumnName="EF_TransmissionTypeId" type="xs:int" />
              <xs:element name="DisplayName" msprop:Generator_ColumnVarNameInTable="columnDisplayName" msprop:Generator_ColumnPropNameInRow="DisplayName" msprop:Generator_ColumnPropNameInTable="DisplayNameColumn" msprop:Generator_UserColumnName="DisplayName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Vehicles" msprop:Generator_TableClassName="VehiclesDataTable" msprop:Generator_TableVarName="tableVehicles" msprop:Generator_TablePropName="Vehicles" msprop:Generator_RowDeletingName="VehiclesRowDeleting" msprop:Generator_UserTableName="Vehicles" msprop:Generator_RowChangingName="VehiclesRowChanging" msprop:Generator_RowEvHandlerName="VehiclesRowChangeEventHandler" msprop:Generator_RowDeletedName="VehiclesRowDeleted" msprop:Generator_RowEvArgName="VehiclesRowChangeEvent" msprop:Generator_RowChangedName="VehiclesRowChanged" msprop:Generator_RowClassName="VehiclesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_VehicleId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_VehicleId" msprop:Generator_ColumnPropNameInRow="EF_VehicleId" msprop:Generator_ColumnPropNameInTable="EF_VehicleIdColumn" msprop:Generator_UserColumnName="EF_VehicleId" type="xs:string" />
              <xs:element name="EF_OptionsConfiguration_HasNavigationSystem" msprop:Generator_ColumnVarNameInTable="columnEF_OptionsConfiguration_HasNavigationSystem" msprop:Generator_ColumnPropNameInRow="EF_OptionsConfiguration_HasNavigationSystem" msprop:Generator_ColumnPropNameInTable="EF_OptionsConfiguration_HasNavigationSystemColumn" msprop:Generator_UserColumnName="EF_OptionsConfiguration_HasNavigationSystem" type="xs:boolean" />
              <xs:element name="EF_OptionsConfiguration_NumberOfSpeeds" msprop:Generator_ColumnVarNameInTable="columnEF_OptionsConfiguration_NumberOfSpeeds" msprop:Generator_ColumnPropNameInRow="EF_OptionsConfiguration_NumberOfSpeeds" msprop:Generator_ColumnPropNameInTable="EF_OptionsConfiguration_NumberOfSpeedsColumn" msprop:Generator_UserColumnName="EF_OptionsConfiguration_NumberOfSpeeds" type="xs:int" />
              <xs:element name="EF_OptionsConfiguration_NumberOfCylinders" msprop:Generator_ColumnVarNameInTable="columnEF_OptionsConfiguration_NumberOfCylinders" msprop:Generator_ColumnPropNameInRow="EF_OptionsConfiguration_NumberOfCylinders" msprop:Generator_ColumnPropNameInTable="EF_OptionsConfiguration_NumberOfCylindersColumn" msprop:Generator_UserColumnName="EF_OptionsConfiguration_NumberOfCylinders" type="xs:int" />
              <xs:element name="EF_OptionsConfiguration_EngineSizeInLiters" msprop:Generator_ColumnVarNameInTable="columnEF_OptionsConfiguration_EngineSizeInLiters" msprop:Generator_ColumnPropNameInRow="EF_OptionsConfiguration_EngineSizeInLiters" msprop:Generator_ColumnPropNameInTable="EF_OptionsConfiguration_EngineSizeInLitersColumn" msprop:Generator_UserColumnName="EF_OptionsConfiguration_EngineSizeInLiters" type="xs:double" />
              <xs:element name="EF_OptionsConfiguration_EF_BodyStyle" msprop:Generator_ColumnVarNameInTable="columnEF_OptionsConfiguration_EF_BodyStyle" msprop:Generator_ColumnPropNameInRow="EF_OptionsConfiguration_EF_BodyStyle" msprop:Generator_ColumnPropNameInTable="EF_OptionsConfiguration_EF_BodyStyleColumn" msprop:Generator_UserColumnName="EF_OptionsConfiguration_EF_BodyStyle" type="xs:int" />
              <xs:element name="EF_OptionsConfiguration_EF_DriveTrainType" msprop:Generator_ColumnVarNameInTable="columnEF_OptionsConfiguration_EF_DriveTrainType" msprop:Generator_ColumnPropNameInRow="EF_OptionsConfiguration_EF_DriveTrainType" msprop:Generator_ColumnPropNameInTable="EF_OptionsConfiguration_EF_DriveTrainTypeColumn" msprop:Generator_UserColumnName="EF_OptionsConfiguration_EF_DriveTrainType" type="xs:int" />
              <xs:element name="EF_OptionsConfiguration_EF_TransmissionType" msprop:Generator_ColumnVarNameInTable="columnEF_OptionsConfiguration_EF_TransmissionType" msprop:Generator_ColumnPropNameInRow="EF_OptionsConfiguration_EF_TransmissionType" msprop:Generator_ColumnPropNameInTable="EF_OptionsConfiguration_EF_TransmissionTypeColumn" msprop:Generator_UserColumnName="EF_OptionsConfiguration_EF_TransmissionType" type="xs:int" />
              <xs:element name="EF_PriceHistoryId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_PriceHistoryId" msprop:Generator_ColumnPropNameInRow="EF_PriceHistoryId" msprop:Generator_ColumnPropNameInTable="EF_PriceHistoryIdColumn" msprop:Generator_UserColumnName="EF_PriceHistoryId" type="xs:string" />
              <xs:element name="ParentProductionModel" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentProductionModel" msprop:Generator_ColumnPropNameInRow="ParentProductionModel" msprop:Generator_ColumnPropNameInTable="ParentProductionModelColumn" msprop:Generator_UserColumnName="ParentProductionModel" type="xs:string" minOccurs="0" />
              <xs:element name="ModelYear" msprop:Generator_ColumnVarNameInTable="columnModelYear" msprop:Generator_ColumnPropNameInRow="ModelYear" msprop:Generator_ColumnPropNameInTable="ModelYearColumn" msprop:Generator_UserColumnName="ModelYear" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="YearlyFinancialAssessments" msprop:Generator_TableClassName="YearlyFinancialAssessmentsDataTable" msprop:Generator_TableVarName="tableYearlyFinancialAssessments" msprop:Generator_TablePropName="YearlyFinancialAssessments" msprop:Generator_RowDeletingName="YearlyFinancialAssessmentsRowDeleting" msprop:Generator_UserTableName="YearlyFinancialAssessments" msprop:Generator_RowChangingName="YearlyFinancialAssessmentsRowChanging" msprop:Generator_RowEvHandlerName="YearlyFinancialAssessmentsRowChangeEventHandler" msprop:Generator_RowDeletedName="YearlyFinancialAssessmentsRowDeleted" msprop:Generator_RowEvArgName="YearlyFinancialAssessmentsRowChangeEvent" msprop:Generator_RowChangedName="YearlyFinancialAssessmentsRowChanged" msprop:Generator_RowClassName="YearlyFinancialAssessmentsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EF_YearlyFinancialAssessmentId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEF_YearlyFinancialAssessmentId" msprop:Generator_ColumnPropNameInRow="EF_YearlyFinancialAssessmentId" msprop:Generator_ColumnPropNameInTable="EF_YearlyFinancialAssessmentIdColumn" msprop:Generator_UserColumnName="EF_YearlyFinancialAssessmentId" type="xs:string" />
              <xs:element name="EF_MissingValueOption" msprop:Generator_ColumnVarNameInTable="columnEF_MissingValueOption" msprop:Generator_ColumnPropNameInRow="EF_MissingValueOption" msprop:Generator_ColumnPropNameInTable="EF_MissingValueOptionColumn" msprop:Generator_UserColumnName="EF_MissingValueOption" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BodyStyles" />
      <xs:field xpath="mstns:EF_BodyStyleId" />
    </xs:unique>
    <xs:unique name="YearValueObservationsKey1">
      <xs:selector xpath=".//mstns:YearValueObservations" />
      <xs:field xpath="mstns:Year" />
      <xs:field xpath="mstns:ParentYearlyFinancialAssessmentId" />
    </xs:unique>
    <xs:unique name="Brands_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Brands" />
      <xs:field xpath="mstns:EF_BrandId" />
    </xs:unique>
    <xs:unique name="Companies_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Companies" />
      <xs:field xpath="mstns:EF_CompanyId" />
    </xs:unique>
    <xs:unique name="Countries_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Countries" />
      <xs:field xpath="mstns:EF_CountryId" />
    </xs:unique>
    <xs:unique name="DealerBrandRelationsKey1">
      <xs:selector xpath=".//mstns:DealerBrandRelations" />
      <xs:field xpath="mstns:ParentDealerId" />
      <xs:field xpath="mstns:RelatedBrandId" />
    </xs:unique>
    <xs:unique name="Dealers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Dealers" />
      <xs:field xpath="mstns:EF_DealerId" />
    </xs:unique>
    <xs:unique name="DealerVehicleRelationsKey1">
      <xs:selector xpath=".//mstns:DealerVehicleRelations" />
      <xs:field xpath="mstns:ParentDealerId" />
      <xs:field xpath="mstns:RelatedVehicleId" />
    </xs:unique>
    <xs:unique name="DriveTrainTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DriveTrainTypes" />
      <xs:field xpath="mstns:EF_DriveTrainTypeId" />
    </xs:unique>
    <xs:unique name="ProductionModels_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ProductionModels" />
      <xs:field xpath="mstns:EF_ProductionModelId" />
    </xs:unique>
    <xs:unique name="TransmissionTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TransmissionTypes" />
      <xs:field xpath="mstns:EF_TransmissionTypeId" />
    </xs:unique>
    <xs:unique name="Vehicles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Vehicles" />
      <xs:field xpath="mstns:EF_VehicleId" />
    </xs:unique>
    <xs:unique name="YearlyFinancialAssessments_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:YearlyFinancialAssessments" />
      <xs:field xpath="mstns:EF_YearlyFinancialAssessmentId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="Company_EF_EarningsHistory" msdata:parent="YearlyFinancialAssessments" msdata:child="Companies" msdata:parentkey="EF_YearlyFinancialAssessmentId" msdata:childkey="EF_EarningsHistoryId" msprop:Generator_UserChildTable="Companies" msprop:Generator_ChildPropName="GetCompaniesRows" msprop:Generator_ParentPropName="YearlyFinancialAssessmentsRow" msprop:Generator_UserRelationName="Company_EF_EarningsHistory" msprop:Generator_RelationVarName="relationCompany_EF_EarningsHistory" msprop:Generator_UserParentTable="YearlyFinancialAssessments" />
      <msdata:Relationship name="Vehicle_EF_PriceHistory" msdata:parent="YearlyFinancialAssessments" msdata:child="Vehicles" msdata:parentkey="EF_YearlyFinancialAssessmentId" msdata:childkey="EF_PriceHistoryId" msprop:Generator_UserChildTable="Vehicles" msprop:Generator_ChildPropName="GetVehiclesRows" msprop:Generator_ParentPropName="YearlyFinancialAssessmentsRow" msprop:Generator_UserRelationName="Vehicle_EF_PriceHistory" msprop:Generator_RelationVarName="relationVehicle_EF_PriceHistory" msprop:Generator_UserParentTable="YearlyFinancialAssessments" />
      <msdata:Relationship name="YearlyFinancialAssessments_YearValueObservations" msdata:parent="YearlyFinancialAssessments" msdata:child="YearValueObservations" msdata:parentkey="EF_YearlyFinancialAssessmentId" msdata:childkey="ParentYearlyFinancialAssessmentId" msprop:Generator_UserChildTable="YearValueObservations" msprop:Generator_ChildPropName="GetYearValueObservationsRows" msprop:Generator_UserParentTable="YearlyFinancialAssessments" msprop:Generator_UserRelationName="YearlyFinancialAssessments_YearValueObservations" msprop:Generator_RelationVarName="relationYearlyFinancialAssessments_YearValueObservations" msprop:Generator_ParentPropName="YearlyFinancialAssessmentsRow" />
      <msdata:Relationship name="Dealers_DealerBrandRelations" msdata:parent="Dealers" msdata:child="DealerBrandRelations" msdata:parentkey="EF_DealerId" msdata:childkey="ParentDealerId" msprop:Generator_UserChildTable="DealerBrandRelations" msprop:Generator_ChildPropName="GetDealerBrandRelationsRows" msprop:Generator_ParentPropName="DealersRow" msprop:Generator_UserRelationName="Dealers_DealerBrandRelations" msprop:Generator_RelationVarName="relationDealers_DealerBrandRelations" msprop:Generator_UserParentTable="Dealers" />
      <msdata:Relationship name="Dealers_DealerVehicleRelations" msdata:parent="Dealers" msdata:child="DealerVehicleRelations" msdata:parentkey="EF_DealerId" msdata:childkey="ParentDealerId" msprop:Generator_UserChildTable="DealerVehicleRelations" msprop:Generator_ChildPropName="GetDealerVehicleRelationsRows" msprop:Generator_ParentPropName="DealersRow" msprop:Generator_UserRelationName="Dealers_DealerVehicleRelations" msprop:Generator_RelationVarName="relationDealers_DealerVehicleRelations" msprop:Generator_UserParentTable="Dealers" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>